﻿using CSharpDesign.DAL;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;

/// <summary>
/// SearchSPBLL 的摘要说明
/// </summary>
public class SearchSPBLL
{
    /// <summary>
    /// 获取商品分类
    /// </summary>
    /// <returns></returns>
    public SqlDataReader GetCommodityCategory()
    {
        return new SqlHelper().GetDataReader("select * from ShangPinFenLei");
    }

    /// <summary>
    /// 获取商品列表
    /// </summary>
    /// <returns></returns>
    public static DataSet GetCommodityList()
    {
        string sql = "";
        sql = "select  * from ShangPin order by SPClick desc ";
        return CommonHelper.GetDataByAdapter(sql);
    }
}